package com.example.demo;

import java.sql.Connection;
import java.sql.Driver;
import java.sql.DriverManager;

public class DBConnection {
    private String FileName;
    private int DBType;
    private Connection conn;
    private  String MySqlDriver;
    private String MySqlURL;
    public DBConnection() {conn = null;}
    public  Connection getConn()
    {
        DBType=1;
        switch (DBType)
        {
            case 1: return (getConnTOMySql());
            default:return null;

        }
    }
public  Connection getConnTOMySql()
{
    try {
        MySqlDriver = "com.mysql.cj.jdbc.Driver";
        MySqlURL = "jdbc:mysql://172.21.32.100:3306/unit7website?user=root&password=123456&useUnicode=true&characterEncoding=UTF-8";
        Class.forName(MySqlDriver).newInstance();
        conn = DriverManager.getConnection(MySqlURL);

    }catch (Exception e) {
    }
    return conn;

}
}
